﻿{ Title: "R_Forecast_PL", WithoutYTDM1:false,isKoMode: true, ForceRate: "YTDM_3", 
Rows: [

{ accountcode: "PL04010101-1", unit: "#T#", exchangerate: false, internalsales: {
    entity: 'All',
    convertT: "RBNW",
    exchangerate: false,
    fields: ['Qty_SI04010201'],
    add: false
}, convertT: "RBNW", description: "Tonnages (Head Products Manufactured)", datarow: true, index: 0
},
{ accountcode: "PL04010101-2", unit: "#T#", exchangerate: false, description: "Tonnages (First Products Manufactured)", convertT: "RBNW", datarow: true, index: 0 },
{ accountcode: "PL04010102", description: "Sales (All manufactured products)", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL04010102-1", "PL04010102-2"],
        equ: "+"
    }
}]
},
{ accountcode: "PL04010102-1", exchangerate: true, internalsales: {
    entity: 'All',
    fields: ['BA_SI04010201'], 
    add: false
}, description: "Sales (Head Products products)", datarow: true, index: 0
},
{ accountcode: "PL04010102-2", exchangerate: true, description: "Sales (First Products products)", datarow: true, index: 0 },
{ accountcode: "PL04010103", exchangerate: true, description: "SBEW Cost", datarow: true, index: 0 },
{ accountcode: "PL04010104", exchangerate: true, description: "VC - Manufactured products", datarow: true, index: 0, internalsales: {
    entity: 'All',
    fields: ['BA_SI04010201'],
    add: true
}
},
{ accountcode: "PL04010105", description: "VM - Manufactured products", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL04010102", "PL04010103", "PL04010104"],
        equ: "+"
    }
}]
},
{ accountcode: "PL04010106", description: "VM / Sales", datarow: true, index: 3, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL04010105", "PL04010102"], addition: "{0}*100",
        equ: "/"
    }
}], digits: 1, unit: "%"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL04010201-1", unit: "#T#", exchangerate: false, convertT: "RBNW", description: "Tonnages  (Head Products Traded)", style: "green_loading", datarow: true, index: 0 },
{ accountcode: "PL04010201-2", unit: "#T#", exchangerate: false, convertT: "RBNW", description: "Tonnages (First Products Traded)", style: "green_loading", datarow: true, index: 0 },
{ accountcode: "PL04010202", description: "Sales  (All Traded Products)", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL040102020-1", "PL040102020-2"],
        equ: "+"
    }
}]
},
{ accountcode: "PL040102020-1", exchangerate: true, description: "Sales (Head Products Traded)", style: "green_loading", datarow: true, index: 0 },
{ accountcode: "PL040102020-2", exchangerate: true, description: "Sales (First Products Traded)", style: "green_loading", datarow: true, index: 0 },
{ accountcode: "PL04010203", exchangerate: true, description: "SBEW Cost", style: "green_loading", datarow: true, index: 0 },
{ accountcode: "PL04010204", exchangerate: true, description: "VC - Traded Products", datarow: true, index: 0 },
{ accountcode: "PL04010205", description: "VM - Traded Products", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL04010202", "PL04010203", "PL04010204"],
        equ: "+"
    }
}]
},
{ emptyrow: true, description: "" },
{ accountcode: "PL04010300", description: "Sales + VM-Traded Products", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL04010102", "PL04010205"],
        equ: "+"
    }
}]
},
{ emptyrow: true, description: "" },
{ accountcode: "PL04010400", exchangerate: true, internalsales: {
    entity: 'All',
    fields: ['BA_SI04040101'],
    add: false
}, description: "Sales - Commission income", datarow: true, index: 0
},
{ emptyrow: true, description: "" },
{ accountcode: "PL04010500", exchangerate: true, internalsales: {
    entity: 'All',
    fields: ['BA_SI04030201'],
    add: false
}, description: "Sales - Services", datarow: true, index: 0
},
{ emptyrow: true, description: "" },
{ accountcode: "PL04010600", description: "VM-Total", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL04010105", "PL04010205", "PL04010400", "PL04010500"],
        equ: "+"
    }
}], ProcessTODO: "from Flash input-Sales Commission&Service-SV03030100"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL04020101", exchangerate: true, description: "Fixed Operating Costs - Net", datarow: true, index: 0,
    internalsales: {
        entity: 'All',
        fields: ['BA_SI04040101'],
        add: true
    }
},

{ emptyrow: true, description: "" },
{ accountcode: "PL04030101", description: "Commercial Contribution (CC)", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL04010105", "PL04010205", "PL04020101", "PL04010400", "PL04010500"],
        equ: "+"
    }
}], ProcessTODO: "=PL04010105+PL04010205+PL04020101"
},
{ accountcode: "PL04030102", description: "CC / (Sales + VM Traded Products)", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL04030101", "PL04010300"], addition: "{0}*100",
        equ: "/"
    }
}], ProcessTODO: "=PL04030101/PL04010300", digits: 1, unit: "%"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL04020201", exchangerate: true, description: "Operating depreciation - Net", datarow: true, index: 0 },

{ emptyrow: true, description: "" },
{ accountcode: "PL04040101", description: "Commercial Margin (CM)", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL04030101", "PL04020201"],
        equ: "+"
    }
}]
},
{ accountcode: "PL04040102", description: "CM / (Sales + VM Traded Products)", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL04040101", "PL04010300"], addition: "{0}*100",
        equ: "/"
    }
}], ProcessTODO: "=PL04040101/PL04010300", digits: 1, unit: "%"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL04020104", exchangerate: true, description: "Admin. Excl. Depreciation - Net", datarow: true, index: 0,
    internalsales: {
        entity: 'All',
        fields: ['BA_SI04030201'],
        add: true
    }
}, 
{ accountcode: "PL04020107", exchangerate: true, description: "R&D Excl. Depreciation - Net", datarow: true, index: 0 },

{ emptyrow: true, description: "" },
{ accountcode: "PL04050101", description: "Economic EBITDA", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL04030101", "PL04020104", "PL04020107"],
        equ: "+"
    }
}]
},
{ accountcode: "PL04050102", description: "Economic EBITDA  / (Sales + VM Traded Products) (%)", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL04050101", "PL04010300"], addition: "{0}*100",
        equ: "/"
    }
}], ProcessTODO: "Calculate:=PL04050101 / PL04010300", digits: 1, unit: "%"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL04020206", exchangerate: true, description: "Depreciation ALL - Net", datarow: true, index: 0 },

{ emptyrow: true, description: "" },
{ accountcode: "PL04060101", description: "Operating profit (OP)", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL04050101", "PL04020206"],
        equ: "+"
    }
}], ProcessTODO: "calculate:=PL04050101+PL04020206"
},
{ accountcode: "PL04060102", description: "OP / (Sales + VM Traded Products) (%)", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL04060101", "PL04010300"], addition: "{0}*100",
        equ: "/"
    }
}], digits: 1, unit: "%"
},
{ emptyrow: true, description: "" }
]}